package com.gdit.zax.entitys;

import java.sql.Timestamp;

import com.gdit.zax.utils.TextUtil;

/**
 * 完整的视频信息
 * @author lenovo
 *

select * from t_video as v
inner join t_section as s on v.SectionId=s.id
inner join t_course as c on s.CourseId=c.Id
inner join t_videotype as vt on v.type=vt.id
inner join t_sectiontype as st on s.type=st.Id
inner join t_coursetype as ct on c.type=ct.Id
inner join t_user as u on s.AnthorId=u.id
where v.AnthorId = ? 
xxxxxxxxxxxxxx
where v.CourseId=29
 */
public class DownRecordALL {
	
	
	private int isnew;//0否 1是
	
	//视频信息
	private int t_video_id;//视频id
	private String t_video_name;//视频名称
	private String t_video_pic;//视频图片
	private int t_video_courseid;//课程id
	private int t_video_sectionid;//章节id
	private String t_video_url;//视频url
	private int t_video_anthorid;//作者id
	private int t_video_commentsum;
	private String t_video_introduction;//视频介绍
	private int t_video_seesum;
	private int t_video_downsum;
	private int t_video_knowledgeid;
	private int t_video_type;//视频类型
	private int t_video_collectsum;
	
	
	private int t_section_id;//章节id
	private String t_section_name;//章节名称
	private String t_section_introduction;//章节介绍
	private int t_section_anthorid;//章节作者id
	private int t_section_type;//章节类型
	
	private int t_course_id;//课程id
	private String t_course_name;//课程名称
	private String t_course_introduction;//课程介绍
	private int t_course_anthorid;//课程作者id
	private int t_course_type;//课程类型
	private int t_course_seesum;//视频播放次数
	private String t_course_pic;//课程图片
	private int t_course_ccollectsum;//课程收藏总数
	private int t_course_commentsum;//评论总数
	
	
	private int t_coursetype_id;//视频类型id
	private String t_coursetype_name;//视频类型名称
	
	private int t_videotype_id;//视频类型id
	private String t_videotype_name;//视频类型名称

	private int t_sectiontype_id;//章节类型id
	private String t_sectiontype_name;//章节类型名称
	
	
	
	//用户信息
	private int t_user_id;//用户id
	private String t_user_username = "";
	private String t_user_imei = "";
	private String t_user_password = "";
	private int t_user_age;
	private int t_user_sex;
	private String t_user_email = "";
	private String t_user_phone = "";
	private String t_user_introduction = "";
	private int t_user_score;
	private String t_user_identitycard = "";//省份证
	private String t_user_truename = "";
	private String t_user_nick = "";
	private String t_user_address = "";
	private String t_user_userhead = "";
	private int t_user_ulevel;
	private int t_user_tlevel;
	private String t_user_logintime;
	
	private String t_user_accesstoken= "";
	private String t_user_logincookie = "";
	private String t_user_loginflag = "";
	private int t_user_schoolid;
	
	
	private int t_downrecord_id;
	private int t_downrecord_courseid;
	private int t_downrecord_sectionid;
	private int t_downrecord_videoid;
	
	
	public int getT_downrecord_id() {
		return t_downrecord_id;
	}
	public void setT_downrecord_id(int tDownrecordId) {
		t_downrecord_id = tDownrecordId;
	}
	public int getT_downrecord_courseid() {
		return t_downrecord_courseid;
	}
	public void setT_downrecord_courseid(int tDownrecordCourseid) {
		t_downrecord_courseid = tDownrecordCourseid;
	}
	public int getT_downrecord_sectionid() {
		return t_downrecord_sectionid;
	}
	public void setT_downrecord_sectionid(int tDownrecordSectionid) {
		t_downrecord_sectionid = tDownrecordSectionid;
	}
	public int getT_downrecord_videoid() {
		return t_downrecord_videoid;
	}
	public void setT_downrecord_videoid(int tDownrecordVideoid) {
		t_downrecord_videoid = tDownrecordVideoid;
	}
	public int getIsnew() {
		return isnew;
	}
	public void setIsnew(int isnew) {
		this.isnew = isnew;
	}
	public int getT_video_collectsum() {
		return t_video_collectsum;
	}
	public void setT_video_collectsum(int tVideoCollectsum) {
		t_video_collectsum = tVideoCollectsum;
	}
	public int getT_course_seesum() {
		return t_course_seesum;
	}
	public void setT_course_seesum(int tCourseSeesum) {
		t_course_seesum = tCourseSeesum;
	}
	public String getT_course_pic() {
		return t_course_pic;
	}
	public void setT_course_pic(String tCoursePic) {
		t_course_pic = tCoursePic;
	}
	public int getT_course_ccollectsum() {
		return t_course_ccollectsum;
	}
	public void setT_course_ccollectsum(int tCourseCcollectsum) {
		t_course_ccollectsum = tCourseCcollectsum;
	}
	public int getT_course_commentsum() {
		return t_course_commentsum;
	}
	public void setT_course_commentsum(int tCourseCommentsum) {
		t_course_commentsum = tCourseCommentsum;
	}
	public int getT_video_id() {
		return t_video_id;
	}
	public void setT_video_id(int tVideoId) {
		t_video_id = tVideoId;
	}
	public String getT_video_name() {
		return t_video_name;
	}
	public void setT_video_name(String tVideoName) {
		t_video_name = tVideoName;
	}
	public String getT_video_pic() {
		return t_video_pic;
	}
	public void setT_video_pic(String tVideoPic) {
		t_video_pic = tVideoPic;
	}
	public int getT_video_courseid() {
		return t_video_courseid;
	}
	public void setT_video_courseid(int tVideoCourseid) {
		t_video_courseid = tVideoCourseid;
	}
	public int getT_video_sectionid() {
		return t_video_sectionid;
	}
	public void setT_video_sectionid(int tVideoSectionid) {
		t_video_sectionid = tVideoSectionid;
	}
	public String getT_video_url() {
		return t_video_url;
	}
	public void setT_video_url(String tVideoUrl) {
		t_video_url = tVideoUrl;
	}
	public int getT_video_anthorid() {
		return t_video_anthorid;
	}
	public void setT_video_anthorid(int tVideoAnthorid) {
		t_video_anthorid = tVideoAnthorid;
	}
	public int getT_video_commentsum() {
		return t_video_commentsum;
	}
	public void setT_video_commentsum(int tVideoCommentsum) {
		t_video_commentsum = tVideoCommentsum;
	}
	public String getT_video_introduction() {
		return t_video_introduction;
	}
	public void setT_video_introduction(String tVideoIntroduction) {
		t_video_introduction = tVideoIntroduction;
	}
	public int getT_video_seesum() {
		return t_video_seesum;
	}
	public void setT_video_seesum(int tVideoSeesum) {
		t_video_seesum = tVideoSeesum;
	}
	public int getT_video_downsum() {
		return t_video_downsum;
	}
	public void setT_video_downsum(int tVideoDownsum) {
		t_video_downsum = tVideoDownsum;
	}
	public int getT_video_knowledgeid() {
		return t_video_knowledgeid;
	}
	public void setT_video_knowledgeid(int tVideoKnowledgeid) {
		t_video_knowledgeid = tVideoKnowledgeid;
	}
	public int getT_video_type() {
		return t_video_type;
	}
	public void setT_video_type(int tVideoType) {
		t_video_type = tVideoType;
	}
	public int getT_section_id() {
		return t_section_id;
	}
	public void setT_section_id(int tSectionId) {
		t_section_id = tSectionId;
	}
	public String getT_section_name() {
		return t_section_name;
	}
	public void setT_section_name(String tSectionName) {
		t_section_name = tSectionName;
	}
	public String getT_section_introduction() {
		return t_section_introduction;
	}
	public void setT_section_introduction(String tSectionIntroduction) {
		t_section_introduction = tSectionIntroduction;
	}
	public int getT_section_anthorid() {
		return t_section_anthorid;
	}
	public void setT_section_anthorid(int tSectionAnthorid) {
		t_section_anthorid = tSectionAnthorid;
	}
	public int getT_section_type() {
		return t_section_type;
	}
	public void setT_section_type(int tSectionType) {
		t_section_type = tSectionType;
	}
	public int getT_course_id() {
		return t_course_id;
	}
	public void setT_course_id(int tCourseId) {
		t_course_id = tCourseId;
	}
	public String getT_course_name() {
		return t_course_name;
	}
	public void setT_course_name(String tCourseName) {
		t_course_name = tCourseName;
	}
	public String getT_course_introduction() {
		return t_course_introduction;
	}
	public void setT_course_introduction(String tCourseIntroduction) {
		t_course_introduction = tCourseIntroduction;
	}
	public int getT_course_anthorid() {
		return t_course_anthorid;
	}
	public void setT_course_anthorid(int tCourseAnthorid) {
		t_course_anthorid = tCourseAnthorid;
	}
	public int getT_course_type() {
		return t_course_type;
	}
	public void setT_course_type(int tCourseType) {
		t_course_type = tCourseType;
	}
	public int getT_videotype_id() {
		return t_videotype_id;
	}
	public void setT_videotype_id(int tVideotypeId) {
		t_videotype_id = tVideotypeId;
	}
	public String getT_videotype_name() {
		return t_videotype_name;
	}
	public void setT_videotype_name(String tVideotypeName) {
		t_videotype_name = tVideotypeName;
	}
	public int getT_sectiontype_id() {
		return t_sectiontype_id;
	}
	public void setT_sectiontype_id(int tSectiontypeId) {
		t_sectiontype_id = tSectiontypeId;
	}
	public String getT_sectiontype_name() {
		return t_sectiontype_name;
	}
	public void setT_sectiontype_name(String tSectiontypeName) {
		t_sectiontype_name = tSectiontypeName;
	}
	public int getT_coursetype_id() {
		return t_coursetype_id;
	}
	public void setT_coursetype_id(int tCoursetypeId) {
		t_coursetype_id = tCoursetypeId;
	}
	public String getT_coursetype_name() {
		return t_coursetype_name;
	}
	public void setT_coursetype_name(String tCoursetypeName) {
		t_coursetype_name = tCoursetypeName;
	}
	public int getT_user_id() {
		return t_user_id;
	}
	public void setT_user_id(int tUserId) {
		t_user_id = tUserId;
	}
	public String getT_user_username() {
		return t_user_username;
	}
	public void setT_user_username(String tUserUsername) {
		t_user_username = tUserUsername;
	}
	public String getT_user_imei() {
		return t_user_imei;
	}
	public void setT_user_imei(String tUserImei) {
		t_user_imei = tUserImei;
	}
	public String getT_user_password() {
		return t_user_password;
	}
	public void setT_user_password(String tUserPassword) {
		t_user_password = tUserPassword;
	}
	public int getT_user_age() {
		return t_user_age;
	}
	public void setT_user_age(int tUserAge) {
		t_user_age = tUserAge;
	}
	public int getT_user_sex() {
		return t_user_sex;
	}
	public void setT_user_sex(int tUserSex) {
		t_user_sex = tUserSex;
	}
	public String getT_user_email() {
		return t_user_email;
	}
	public void setT_user_email(String tUserEmail) {
		t_user_email = tUserEmail;
	}
	public String getT_user_phone() {
		return t_user_phone;
	}
	public void setT_user_phone(String tUserPhone) {
		t_user_phone = tUserPhone;
	}
	public String getT_user_introduction() {
		return t_user_introduction;
	}
	public void setT_user_introduction(String tUserIntroduction) {
		t_user_introduction = tUserIntroduction;
	}
	public int getT_user_score() {
		return t_user_score;
	}
	public void setT_user_score(int tUserScore) {
		t_user_score = tUserScore;
	}
	public String getT_user_identitycard() {
		return t_user_identitycard;
	}
	public void setT_user_identitycard(String tUserIdentitycard) {
		t_user_identitycard = tUserIdentitycard;
	}
	public String getT_user_truename() {
		return t_user_truename;
	}
	public void setT_user_truename(String tUserTruename) {
		t_user_truename = tUserTruename;
	}
	public String getT_user_nick() {
		return t_user_nick;
	}
	public void setT_user_nick(String tUserNick) {
		t_user_nick = tUserNick;
	}
	public String getT_user_address() {
		return t_user_address;
	}
	public void setT_user_address(String tUserAddress) {
		t_user_address = tUserAddress;
	}
	public String getT_user_userhead() {
		return t_user_userhead;
	}
	public void setT_user_userhead(String tUserUserhead) {
		t_user_userhead = tUserUserhead;
	}
	public int getT_user_ulevel() {
		return t_user_ulevel;
	}
	public void setT_user_ulevel(int tUserUlevel) {
		t_user_ulevel = tUserUlevel;
	}
	public int getT_user_tlevel() {
		return t_user_tlevel;
	}
	public void setT_user_tlevel(int tUserTlevel) {
		t_user_tlevel = tUserTlevel;
	}
	public String getT_user_logintime() {
		return t_user_logintime;
	}
	public void setT_user_logintime(String tUserLogintime) {
		t_user_logintime = tUserLogintime;
	}
	public String getT_user_accesstoken() {
		return t_user_accesstoken;
	}
	public void setT_user_accesstoken(String tUserAccesstoken) {
		t_user_accesstoken = tUserAccesstoken;
	}
	public String getT_user_logincookie() {
		return t_user_logincookie;
	}
	public void setT_user_logincookie(String tUserLogincookie) {
		t_user_logincookie = tUserLogincookie;
	}
	public String getT_user_loginflag() {
		return t_user_loginflag;
	}
	public void setT_user_loginflag(String tUserLoginflag) {
		t_user_loginflag = tUserLoginflag;
	}
	public int getT_user_schoolid() {
		return t_user_schoolid;
	}
	public void setT_user_schoolid(int tUserSchoolid) {
		t_user_schoolid = tUserSchoolid;
	}
	
	
	
	

	
	private Timestamp t_video_addtime;//视频加入时间
	private Timestamp t_section_addtime;//章节加入时间
	private Timestamp t_course_addtime;//课程加入时间
	private Timestamp t_user_addtime;//用户加入时间
	private Timestamp t_coursetype_addtime;//课程类型加入时间
	private Timestamp t_videotype_addtime;//视频类型加入时间
	private Timestamp t_sectiontype_addtime;//章节类型加入时间
	private Timestamp t_downrecord_addtime;//加入时间
	
	public String getT_downrecord_addtime() {
		return t_downrecord_addtime.toString().replace(".0", "");
	}
	public void setT_downrecord(Timestamp tVideoAddtime) {
		t_downrecord_addtime = tVideoAddtime;
	}
	
	public String getT_video_addtime() {
		return t_video_addtime.toString().replace(".0", "");
	}
	public void setT_video_addtime(Timestamp tVideoAddtime) {
		t_video_addtime = tVideoAddtime;
	}
	public String getT_section_addtime() {
		return  t_section_addtime.toString().replace(".0", "");
	}
	public void setT_section_addtime(Timestamp tSectionAddtime) {
		t_section_addtime = tSectionAddtime;
	}
	public String getT_course_addtime() {
		return t_course_addtime.toString().replace(".0", "");
	}
	public void setT_course_addtime(Timestamp tCourseAddtime) {
		t_course_addtime = tCourseAddtime;
	}
	public String getT_videotype_addtime() {
		return t_videotype_addtime.toString().replace(".0", "");
	}
	public void setT_videotype_addtime(Timestamp tVideotypeAddtime) {
		t_videotype_addtime = tVideotypeAddtime;
	}
	public String getT_sectiontype_addtime() {
		return t_sectiontype_addtime.toString().replace(".0", "");
	}
	public void setT_sectiontype_addtime(Timestamp tSectiontypeAddtime) {
		t_sectiontype_addtime = tSectiontypeAddtime;
	}
	public String getT_coursetype_addtime() {
		return t_coursetype_addtime.toString().replace(".0", "");
	}
	public void setT_coursetype_addtime(Timestamp tCoursetypeAddtime) {
		t_coursetype_addtime = tCoursetypeAddtime;
	}
	public String getT_user_addtime() {
		return t_user_addtime.toString().replace(".0", "");
	}
	public void setT_user_addtime(Timestamp tUserAddtime) {
		t_user_addtime = tUserAddtime;
	}
	
	
	
//	public String getAddtime() {
//		return addtime.toLocaleString().replace(".0", "");
//	}
//	public void setAddtime(Timestamp addtime) {
//		this.addtime = addtime;
//	}
	
	
}
